DROP TABLE IF EXISTS `companies`;
CREATE TABLE `companies` (
  `id` bigint(99) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `website` varchar(255) default NULL,
  `first_name` varchar(255) default NULL,
  `last_name` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `addr` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `zipcode` varchar(255) default NULL,
  `office_phone_number` varchar(255) default NULL,
  `toll_free_number` varchar(255) default NULL,
  `fax_number` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `airport_one` varchar(255) default NULL,
  `airport_two` varchar(255) default NULL,
  `airport_three` varchar(255) default NULL,
  `airport_four` varchar(255) default NULL,
  `target_area_one` varchar(255) default NULL,
  `target_area_one_zipcode` varchar(255) default NULL,
  `target_area_two` varchar(255) default NULL,
  `target_area_two_zipcode` varchar(255) default NULL,  
  `dt_changed` timestamp(14) NOT NULL,  
  PRIMARY KEY  (`id`)
) TYPE=MyISAM; 

  FOREIGN KEY (`service_id`) REFERENCES services(id) ON DELETE CASCADE,
  FOREIGN KEY (`fleet_id`) REFERENCES fleet(id) ON DELETE CASCADE